CREATE PROC [dbo].[InserLablePrice]
    @Code1 VARCHAR(100),
    @Qty VARCHAR(5),
    @Anbar VARCHAR(5),
    @Database VARCHAR(6),
    @executecommand VARCHAR(MAX) = NULL
AS


DECLARE @SQLString NVARCHAR(MAX);
SET @Code1 = REPLACE(@Code1,'','')
IF LEN(@Code1) >= 53
SET @Code1 = SUBSTRING(@Code1,4,13)

SET @SQLString
    = N'select  @GoodsCode = k_code from [' + @Database + N'].[dbo].[TblBasket_Kala] where (K_Code_B = @InputCode)';
EXECUTE sp_executesql @SQLString,
                      N'@InputCode Varchar(15) ,  @GoodsCode varchar(15) OUTPUT',
                      @InputCode = @Code1,
                      @GoodsCode = @Code1 OUTPUT;

/*insert into tblHpda
(Kind_Flag ,KindSave)
Values(1,2)*/
IF (@Code1 <> '')
   AND (@Code1 IS NOT NULL)
    SET @executecommand
        = 'INSERT INTO tblPdaLabel
(
    
    K_Code,
    K_Qty,
    A_Code,
    Status,
	Name1
)
VALUES
(''' + @Code1 + ''',''' + @Qty + ''',''' + @Anbar + ''',''4'',
(select Name1 from [' + @Database + '].[dbo].[KalaId] where K_Code = ''' + @Code1 + ''' or Barcode = ''' + @Code1
          + ''' ))';


--PRINT @executecommand
EXEC (@executecommand);
